{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " 驱动器 C 中的卷是 OS\n",
      " 卷的序列号是 AE6F-00B3\n",
      "\n",
      " C:\\Users\\27420\\PycharmProjects\\训练\\gitee\\future-teddy\\teddy-B\\code\\data 的目录\n",
      "\n",
      "2021/11/14  19:28    <DIR>          .\n",
      "2021/11/14  19:28    <DIR>          ..\n",
      "2021/11/14  13:52            12,021 data_new.xlsx\n",
      "2021/11/14  13:48           174,612 result1_1.xlsx\n",
      "2021/11/14  10:19           184,712 result1_2.xlsx\n",
      "2021/11/14  11:19           410,798 result2_1.xlsx\n",
      "2021/11/14  11:46            93,707 result2_2.xlsx\n",
      "2021/11/14  14:44           375,424 result2_3.xlsx\n",
      "2021/11/14  11:29            82,651 result3_2.xlsx\n",
      "2021/11/14  15:20             6,013 result3_3.xlsx\n",
      "2021/11/14  18:59            30,748 result4_2.xlsx\n",
      "2021/11/02  20:09           196,721 附件1.xlsx\n",
      "2021/11/02  20:09           575,770 附件2.xlsx\n",
      "2021/11/02  20:10            40,230 附件3.xlsx\n",
      "2021/11/02  20:11            22,801 附件4.xlsx\n",
      "2021/11/14  15:51            11,464 复混肥料.xlsx\n",
      "2021/11/14  17:48         2,088,119 下载1.png\n",
      "2021/11/14  15:51             9,470 有机肥料.xlsx\n",
      "2021/11/14  15:51             7,565 有机-无机复混肥料.xlsx\n",
      "              17 个文件      4,322,826 字节\n",
      "               2 个目录 108,084,576,256 可用字节\n"
     ]
    }
   ],
   "source": [
    "ls data "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "#导包\n",
    "import re\n",
    "import array\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import datetime\n",
    "import jieba\n",
    "import matplotlib\n",
    "import matplotlib.pyplot as plt\n",
    "matplotlib.rcParams['font.sans-serif'] = ['SimHei'] \n",
    "matplotlib.rcParams['font.family']='sans-serif'\n",
    "matplotlib.rcParams['axes.unicode_minus'] = False "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 任务 4.1\t设计算法或处理流程，从附件 4 技术指标中提取出氮、磷、钾养分和有机质的百分比，以及肥料含氯的程度。请在报告中给出处理思路及过程， 并将结果保存到文件“result4_1.xlsx”中。"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "注 如果技术指标中只给出总养分百分比（“≥”按照“=”处理）而无明细数据，则氮、磷、钾养分的百分比按照总百分比的 1/3 来计算，结果保留 3 位小数（例如 1.0%，即 0.010）。复混肥料属于无机肥料，它的有机质百分比设定为 0。含氯情况分为“无氯”、“低氯”、“中氯”和“高氯”4 种。如果肥料产品的技术指标中没有给出含氯情况，则视为“无氯”；如果注明“含氯”，则视为“低氯”。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>序号</th>\n",
       "      <th>产品通用名称</th>\n",
       "      <th>技术指标</th>\n",
       "      <th>原料与占比</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥35%（14-8-13）   硫酸钾型</td>\n",
       "      <td>尿素 (占15%),高岭土 (占15.5%),硫酸铵 (占28.16%),磷酸一铵 (占16...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥30%（15-6-9）   中氯</td>\n",
       "      <td>尿素 (占15%),高岭土 (占30.23%),氯化铵 (占28%),磷酸一铵 (占12.2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥5% ,有机质≥45%</td>\n",
       "      <td>木薯渣（干基） (占84.9%),菌种 (占0.1%),黄豆渣 (占15%)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分(N+P2O5+K2O)≥43％ （10―18―15）含氯（低氯）</td>\n",
       "      <td>尿素 (占15%),高岭土 (占20%),粉状磷酸一铵 (占40%),氯化钾 (占25%)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>总养分(N+P2O5+K2O)≥5.0％ 有机质≥45％ 酸碱度（PH）  5.5∽8.5</td>\n",
       "      <td>畜禽粪便 (占50%),菌种 (占2%),桐 麸 (占30%),滤 泥 (占18%)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   序号 产品通用名称                                           技术指标  \\\n",
       "0   1   复混肥料            总养分（N+P2O5+K2O）≥35%（14-8-13）   硫酸钾型   \n",
       "1   2   复混肥料               总养分（N+P2O5+K2O）≥30%（15-6-9）   中氯   \n",
       "2   3   有机肥料                         N+P2O5+K2O≥5% ,有机质≥45%   \n",
       "3   4   复混肥料           总养分(N+P2O5+K2O)≥43％ （10―18―15）含氯（低氯）   \n",
       "4   5   有机肥料  总养分(N+P2O5+K2O)≥5.0％ 有机质≥45％ 酸碱度（PH）  5.5∽8.5   \n",
       "\n",
       "                                               原料与占比  \n",
       "0  尿素 (占15%),高岭土 (占15.5%),硫酸铵 (占28.16%),磷酸一铵 (占16...  \n",
       "1  尿素 (占15%),高岭土 (占30.23%),氯化铵 (占28%),磷酸一铵 (占12.2...  \n",
       "2             木薯渣（干基） (占84.9%),菌种 (占0.1%),黄豆渣 (占15%)  \n",
       "3      尿素 (占15%),高岭土 (占20%),粉状磷酸一铵 (占40%),氯化钾 (占25%)  \n",
       "4         畜禽粪便 (占50%),菌种 (占2%),桐 麸 (占30%),滤 泥 (占18%)  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 读取数据\n",
    "data = pd.read_excel('data/附件4.xlsx')\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\ProgramData\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \"\"\"\n"
     ]
    }
   ],
   "source": [
    "# 将技术指标的数据全部转为字符串\n",
    "data['技术指标'] = data['技术指标'].apply(str)\n",
    "# 将技术指标数据的空格去除\n",
    "for i in range(len(data)):\n",
    "    data['技术指标'][i] = str(data['技术指标'][i]).replace(' ', '')\n",
    "# 筛选出有机肥料数据\n",
    "organic_data = data[data['产品通用名称'] == '有机肥料']\n",
    "# 筛选出复混肥料的数据\n",
    "mixing_data = data[data['产品通用名称']=='复混肥料']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "data.to_excel('data/result4_1.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>序号</th>\n",
       "      <th>产品通用名称</th>\n",
       "      <th>技术指标</th>\n",
       "      <th>原料与占比</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥35%（14-8-13）硫酸钾型</td>\n",
       "      <td>尿素 (占15%),高岭土 (占15.5%),硫酸铵 (占28.16%),磷酸一铵 (占16...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥30%（15-6-9）中氯</td>\n",
       "      <td>尿素 (占15%),高岭土 (占30.23%),氯化铵 (占28%),磷酸一铵 (占12.2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥5%,有机质≥45%</td>\n",
       "      <td>木薯渣（干基） (占84.9%),菌种 (占0.1%),黄豆渣 (占15%)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分(N+P2O5+K2O)≥43％（10―18―15）含氯（低氯）</td>\n",
       "      <td>尿素 (占15%),高岭土 (占20%),粉状磷酸一铵 (占40%),氯化钾 (占25%)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>总养分(N+P2O5+K2O)≥5.0％有机质≥45％酸碱度（PH）5.5∽8.5</td>\n",
       "      <td>畜禽粪便 (占50%),菌种 (占2%),桐 麸 (占30%),滤 泥 (占18%)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   序号 产品通用名称                                       技术指标  \\\n",
       "0   1   复混肥料           总养分（N+P2O5+K2O）≥35%（14-8-13）硫酸钾型   \n",
       "1   2   复混肥料              总养分（N+P2O5+K2O）≥30%（15-6-9）中氯   \n",
       "2   3   有机肥料                      N+P2O5+K2O≥5%,有机质≥45%   \n",
       "3   4   复混肥料        总养分(N+P2O5+K2O)≥43％（10―18―15）含氯（低氯）   \n",
       "4   5   有机肥料  总养分(N+P2O5+K2O)≥5.0％有机质≥45％酸碱度（PH）5.5∽8.5   \n",
       "\n",
       "                                               原料与占比  \n",
       "0  尿素 (占15%),高岭土 (占15.5%),硫酸铵 (占28.16%),磷酸一铵 (占16...  \n",
       "1  尿素 (占15%),高岭土 (占30.23%),氯化铵 (占28%),磷酸一铵 (占12.2...  \n",
       "2             木薯渣（干基） (占84.9%),菌种 (占0.1%),黄豆渣 (占15%)  \n",
       "3      尿素 (占15%),高岭土 (占20%),粉状磷酸一铵 (占40%),氯化钾 (占25%)  \n",
       "4         畜禽粪便 (占50%),菌种 (占2%),桐 麸 (占30%),滤 泥 (占18%)  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result4_1 = pd.read_excel('data/result4_1.xlsx')\n",
    "result4_1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 将复混肥料的有机质百分比全部置为 0\n",
    "for x in mixing_data['序号']:\n",
    "    result4_1.loc[result4_1['序号']==x,'有机质百分比'] = '0%'\n",
    "result4_1.to_excel('data/result4_1.xlsx',encoding='gbk')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 将存在\"有机质≥\"字符串的技术指标的有机百分比取出\n",
    "for x in list(data.index):\n",
    "    i = data.loc[x]['序号']\n",
    "    if ('有机质≥' in data.loc[x]['技术指标']) == True:\n",
    "            # 查找“有机质≥”的位置\n",
    "            pos = data.loc[x]['技术指标'].find('有机质≥')\n",
    "            # num 为有机质的值\n",
    "            num = ''\n",
    "            strs = data.loc[x]['技术指标']\n",
    "            for y in range(pos+4,len(strs)):\n",
    "                if strs[y]=='%' or strs[y]=='％':\n",
    "                    num = num+'%'\n",
    "                    break\n",
    "                else:\n",
    "                    num = num+strs[y]\n",
    "            result4_1.loc[result4_1['序号']==i,'有机质百分比'] = num\n",
    "result4_1.to_excel('data/result4_1.xlsx',encoding='gbk')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 处理含氯指标为0的情况\n",
    "for x in list(data.index):\n",
    "    i = data.loc[x]['序号']\n",
    "    if ('氯' in data.loc[x]['技术指标']) == False:\n",
    "        result4_1.loc[result4_1['序号']==i,'含氯情况'] = 0\n",
    "result4_1.to_excel('data/result4_1.xlsx',encoding='gbk')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 将存在\"N+P2O5+K2O≥\"字符串的技术指标的氮，磷，钾百分比计算出取出\n",
    "for x in list(data.index):\n",
    "    i = data.loc[x]['序号']\n",
    "    if ('N+P2O5+K2O≥' in data.loc[x]['技术指标']) == True:\n",
    "        # 查找“N+P2O5+K2O≥”的位置\n",
    "        pos = data.loc[x]['技术指标'].find('N+P2O5+K2O≥')\n",
    "        # num 为氮，磷，钾的值\n",
    "        num = ''\n",
    "        \n",
    "        # str为技术指标字符串\n",
    "        strs = data.loc[x]['技术指标']\n",
    "        \n",
    "        # 将总百分比解析出来\n",
    "        for y in range(pos+len('N+P2O5+K2O≥'),len(strs)):\n",
    "            if strs[y]=='%' or strs[y]=='％':\n",
    "                break\n",
    "            else:\n",
    "                num = num+strs[y]\n",
    "                \n",
    "        # 根据得到的总百分比来计算 氮，磷，钾 的情况          \n",
    "        num = float(num)    \n",
    "        num = round(num,2)\n",
    "        \n",
    "        # 定义正则表达式\n",
    "        p = re.compile('（[0-9][0-9]―[0-9][0-9]―[0-9][0-9]）')\n",
    "#         p1 = re.compile('（[0-9][0-9]-[0-9][0-9]-[0-9][0-9]）')\n",
    "        # 判断（10―18―15）这种配比在不在字符串\n",
    "        if (p.match(data.loc[x]['技术指标']))==True:\n",
    "            # 有配比，根据配比计算 氮，磷，钾\n",
    "            x = data.loc[x]['技术指标'].split('（')[1]\n",
    "            x = x.split(')')[1]\n",
    "            \n",
    "            N = x.split('―')[0]+'%'\n",
    "            P = x.split('―')[1]+'%'\n",
    "            K = x.split('―')[2]+'%'\n",
    "            \n",
    "            result4_1.loc[result4_1['序号']==i,'总氮百分比'] = N\n",
    "            result4_1.loc[result4_1['序号']==i,'P2O5百分比'] = P\n",
    "            result4_1.loc[result4_1['序号']==i,'K2O百分比'] = K    \n",
    "#         elif (p1.match(data.loc[x]['技术指标'])) == True:\n",
    "#               # 有配比，根据配比计算 氮，磷，钾\n",
    "#             x = data.loc[x]['技术指标'].split('（')[1]\n",
    "#             x = x.split(')')[1]\n",
    "            \n",
    "#             N = x.split('―')[0]+'%'\n",
    "#             P = x.split('―')[1]+'%'\n",
    "#             K = x.split('―')[2]+'%'\n",
    "            \n",
    "#             result4_1.loc[result4_1['序号']==i,'总氮百分比'] = N\n",
    "#             result4_1.loc[result4_1['序号']==i,'P2O5百分比'] = P\n",
    "#             result4_1.loc[result4_1['序号']==i,'K2O百分比'] = K    \n",
    "        else:\n",
    "            # 无配比，根据总百分比除以三\n",
    "            N = str(round(num/3,2))+'%'\n",
    "            P = str(round(num/3,2))+'%'\n",
    "            K = str(round(num/3,2))+'%'\n",
    "            result4_1.loc[result4_1['序号']==i,'总氮百分比'] = N\n",
    "            result4_1.loc[result4_1['序号']==i,'P2O5百分比'] = P\n",
    "            result4_1.loc[result4_1['序号']==i,'K2O百分比'] = K    \n",
    "result4_1.to_excel('data/result4_1.xlsx',encoding='gbk')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "result4_1 = pd.read_excel('data/result4_1.xlsx')\n",
    "data = pd.read_excel('data/附件4.xlsx')\n",
    "NPK_data = result4_1[['总氮百分比','P2O5百分比','K2O百分比']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 读取数据\n",
    "data = pd.read_excel('data/附件4.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\ProgramData\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \"\"\"\n"
     ]
    }
   ],
   "source": [
    "# 将技术指标的数据全部转为字符串\n",
    "data['技术指标'] = data['技术指标'].apply(str)\n",
    "# 将技术指标数据的空格去除\n",
    "for i in range(len(data)):\n",
    "    data['技术指标'][i] = str(data['技术指标'][i]).replace(' ', '')\n",
    "# 筛选出有机肥料数据\n",
    "organic_data = data[data['产品通用名称'] == '有机肥料']\n",
    "# 筛选出复混肥料的数据\n",
    "mixing_data = data[data['产品通用名称']=='复混肥料']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "result4_1 = pd.read_excel('data/result4_1.xlsx')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 将复混肥料的有机质百分比全部置为 0\n",
    "for x in mixing_data['序号']:\n",
    "    result4_1.loc[result4_1['序号']==x,'有机质百分比'] = '0%'\n",
    "result4_1.to_excel('data/result4_1.xlsx',encoding='gbk')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 将存在\"有机质≥\"字符串的技术指标的有机百分比取出\n",
    "for x in list(data.index):\n",
    "    i = data.loc[x]['序号']\n",
    "    if ('有机质≥' in data.loc[x]['技术指标']) == True:\n",
    "            # 查找“有机质≥”的位置\n",
    "            pos = data.loc[x]['技术指标'].find('有机质≥')\n",
    "            # num 为有机质的值\n",
    "            num = ''\n",
    "            strs = data.loc[x]['技术指标']\n",
    "            for y in range(pos+4,len(strs)):\n",
    "                if strs[y]=='%' or strs[y]=='％':\n",
    "                    num = num+'%'\n",
    "                    break\n",
    "                else:\n",
    "                    num = num+strs[y]\n",
    "            result4_1.loc[result4_1['序号']==i,'有机质百分比'] = num\n",
    "result4_1.to_excel('data/result4_1.xlsx',encoding='gbk')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>序号</th>\n",
       "      <th>产品通用名称</th>\n",
       "      <th>技术指标</th>\n",
       "      <th>原料与占比</th>\n",
       "      <th>有机质百分比</th>\n",
       "      <th>含氯情况</th>\n",
       "      <th>总氮百分比</th>\n",
       "      <th>P2O5百分比</th>\n",
       "      <th>K2O百分比</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥35%（14-8-13）硫酸钾型</td>\n",
       "      <td>尿素 (占15%),高岭土 (占15.5%),硫酸铵 (占28.16%),磷酸一铵 (占16...</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥30%（15-6-9）中氯</td>\n",
       "      <td>尿素 (占15%),高岭土 (占30.23%),氯化铵 (占28%),磷酸一铵 (占12.2...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥5%,有机质≥45%</td>\n",
       "      <td>木薯渣（干基） (占84.9%),菌种 (占0.1%),黄豆渣 (占15%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.67%</td>\n",
       "      <td>1.67%</td>\n",
       "      <td>1.67%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分(N+P2O5+K2O)≥43％（10―18―15）含氯（低氯）</td>\n",
       "      <td>尿素 (占15%),高岭土 (占20%),粉状磷酸一铵 (占40%),氯化钾 (占25%)</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>总养分(N+P2O5+K2O)≥5.0％有机质≥45％酸碱度（PH）5.5∽8.5</td>\n",
       "      <td>畜禽粪便 (占50%),菌种 (占2%),桐 麸 (占30%),滤 泥 (占18%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>有机-无机复混肥料</td>\n",
       "      <td>总养分(N+P2O5+K2O)≥20％（10―4―6）有机质≥20％含氯</td>\n",
       "      <td>尿素 (占10%),氯化铵 (占22%),肥料级磷酸氢钙 (占20%),氯化钾 (占10%)...</td>\n",
       "      <td>20%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥5%，有机质≥45%</td>\n",
       "      <td>甘蔗制糖滤泥 (占85%),复合发酵菌 (占0.05%),米糠 (占10%),酒精发酵浓缩液...</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥6%有机质≥50%水分≤30%酸碱度（pH）5.5—8.5</td>\n",
       "      <td>滤泥 (占78.4%),发酵菌剂 (占0.1%),酒精废液 (占21.5%)</td>\n",
       "      <td>50%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0%</td>\n",
       "      <td>2.0%</td>\n",
       "      <td>2.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥7%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5</td>\n",
       "      <td>滤泥 (占78.6%),发酵菌剂 (占0.1%),酒精废液 (占21.3%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.33%</td>\n",
       "      <td>2.33%</td>\n",
       "      <td>2.33%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥7%有机质≥55%水分≤30%酸碱度（pH）5.5—8.5</td>\n",
       "      <td>滤泥 (占77.9%),发酵菌剂 (占0.1%),酒精废液 (占22%)</td>\n",
       "      <td>55%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.33%</td>\n",
       "      <td>2.33%</td>\n",
       "      <td>2.33%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥9%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5</td>\n",
       "      <td>滤泥 (占76.6%),发酵菌剂 (占0.1%),酒精废液 (占23.3%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0%</td>\n",
       "      <td>3.0%</td>\n",
       "      <td>3.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥10%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5</td>\n",
       "      <td>滤泥 (占75.6%),发酵菌剂 (占0.1%),酒精废液 (占24.3%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.33%</td>\n",
       "      <td>3.33%</td>\n",
       "      <td>3.33%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>N+P2O5+K2O≥35%（15-8-12）高氯</td>\n",
       "      <td>尿素 (占14.9%),高岭土 (占15%),硫酸铵 (占32.6%),磷酸一铵  (占17...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.67%</td>\n",
       "      <td>11.67%</td>\n",
       "      <td>11.67%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥10%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5</td>\n",
       "      <td>滤泥 (占75.6%),发酵菌剂 (占0.1%),酒精废液 (占24.3%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.33%</td>\n",
       "      <td>3.33%</td>\n",
       "      <td>3.33%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥11%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5</td>\n",
       "      <td>滤泥 (占75.8%),发酵菌剂 (占0.1%),酒精废液 (占24.1%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.67%</td>\n",
       "      <td>3.67%</td>\n",
       "      <td>3.67%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥12%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5</td>\n",
       "      <td>滤泥 (占73.6%),发酵菌剂 (占0.1%),酒精废液 (占26.3%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0%</td>\n",
       "      <td>4.0%</td>\n",
       "      <td>4.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>N+P2O5+K2O≥30%（12-8-10）高氯</td>\n",
       "      <td>尿素 (占4.5%),高岭土 (占20%),硫酸铵 (占41.2%),磷酸一铵  (占17....</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0%</td>\n",
       "      <td>10.0%</td>\n",
       "      <td>10.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>N+P2O5+K2O≥30%（14-7-9）高氯</td>\n",
       "      <td>尿素 (占10.2%),高岭土 (占20%),硫酸铵 (占39.2%),磷酸一铵  (占15...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0%</td>\n",
       "      <td>10.0%</td>\n",
       "      <td>10.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>N+P2O5+K2O≥40%（17-8-15）硫酸钾型</td>\n",
       "      <td>尿素 (占27.2%),高岭土 (占10%),硫酸铵 (占15.1%),磷酸一铵  (占17...</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.33%</td>\n",
       "      <td>13.33%</td>\n",
       "      <td>13.33%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>N+P2O5+K2O≥46%（15-13-18）含氯（高氯）</td>\n",
       "      <td>尿素 (占23.3%),高岭土 (占10%),硫酸铵 (占9.1%),磷酸一铵  (占28....</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.33%</td>\n",
       "      <td>15.33%</td>\n",
       "      <td>15.33%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>N+P2O5+K2O≥30%，（16-6-8），含氯（低氯）</td>\n",
       "      <td>尿素 (占32.5%),磷酸一铵 (占12%),氯化钾 (占13.5%),钙粉 (占42%)</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0%</td>\n",
       "      <td>10.0%</td>\n",
       "      <td>10.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥5.0%有机质≥45%</td>\n",
       "      <td>滤泥 (占50%),发酵菌 (占0.1%),木薯渣 (占9.9%),甘蔗渣 (占40%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>有机质的质量分数（以烘干基计），%</td>\n",
       "      <td>≥45总养分（氮+五氧化二磷+氧化钾）的质量分数（以烘干基计），%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥5%，有机质≥45%</td>\n",
       "      <td>甘蔗滤泥 (占25%), (占0%),烟末、烟梗  (占30%),茶麸米糠  (占45%),...</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.67%</td>\n",
       "      <td>1.67%</td>\n",
       "      <td>1.67%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>N+P2O5+K2O≥38%（12-8-18）硫酸钾型</td>\n",
       "      <td>尿素 (占12.2%),高岭土 (占10%),硫酸铵 (占24.2%),磷酸一铵  (占17...</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.67%</td>\n",
       "      <td>12.67%</td>\n",
       "      <td>12.67%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>有机-无机复混肥料</td>\n",
       "      <td>1、养分（N+P2O5+K2O）≥25%2、有机质≥15%</td>\n",
       "      <td>虑泥 (占25.5%),发酵菌剂 (占0.5%),酒精渣 (占10%),糖蜜浓缩废液 (占1...</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥12%有机质≥45%</td>\n",
       "      <td>鸡粪 (占50%),发酵菌剂 (占0.1%),骨粉 (占10%),烟粉 (占10%),糖蜜 ...</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0%</td>\n",
       "      <td>4.0%</td>\n",
       "      <td>4.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥40%（17-7-16）硫酸钾型含硝态氮</td>\n",
       "      <td>46%尿素 (占23%),高岭土 (占13%),55%磷酸一铵 (占14.5%),50%硫酸...</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>总养分≥5.0%有机质≧45%含氯：0</td>\n",
       "      <td>滤泥 (占60%),发酵菌 (占1%),烟粉 (占20%),桐麸 (占19%)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>总养分(N+P2O5+K2O)≥5.0%有机质≥45%</td>\n",
       "      <td>罗汉果渣 (占50%),发酵菌（生物菌） (占1%),烟粉 (占25%),糖厂滤泥 (占24%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>171</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分(N+P2o5+K2O)≥30%</td>\n",
       "      <td>尿素 (占35.5%),高岭土 (占21%),氯化铵 (占35%),氯化钾 (占8.5%)</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>172</td>\n",
       "      <td>掺混肥料</td>\n",
       "      <td>总养分(N+P2o5+K2O)≥48%</td>\n",
       "      <td>尿素 (占20.5%),磷酸二铵 (占17.5%),30%氮钾肥 (占31%),氯化钾 (占...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>173</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分≥40.0%（18-7-15）含氯（高氯）枸溶性磷</td>\n",
       "      <td>尿素 (占21.5%),腐殖酸 (占2.25%),高岭土 (占2.94%),氯化铵 (占26...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>174</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>2017-08-1500:00:00</td>\n",
       "      <td>尿素（养分≥46%） (占15.2%),生化黄腐酸钾 (占4.2%),硫酸钾（养分≥52%）...</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>175</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥33%含氯（中氯）养分配比：17-6-10</td>\n",
       "      <td>尿 素（养分≥46%） (占4.4%),生化黄腐酸钾 (占3%),磷酸一铵（养分≥58%） ...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>176</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥35%中氯养分配比：18-7-10</td>\n",
       "      <td>尿 素（养分≥46%） (占17%),生化黄腐酸钾 (占7.9%),磷酸一铵（养分≥58%）...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>177</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>总养份≥45%，有机质≥60%不含氯</td>\n",
       "      <td>罗汉果渣 (占79.9%),发酵菌剂 (占0.1%), (占0%),酒糟 (占20%)</td>\n",
       "      <td>60%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>178</td>\n",
       "      <td>有机-无机复混肥料</td>\n",
       "      <td>N+P2O5+K2O≥30%（15-5-10），有机质≥15%，含氯</td>\n",
       "      <td>尿素 (占15%),高岭土 (占9%),氯化铵 (占12%),硫酸铵 (占20%),58%磷...</td>\n",
       "      <td>15%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0%</td>\n",
       "      <td>10.0%</td>\n",
       "      <td>10.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>179</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥5%有机质≥45%</td>\n",
       "      <td>泥炭土 (占40%),米糠 (占20%),蔗渣 (占40%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.67%</td>\n",
       "      <td>1.67%</td>\n",
       "      <td>1.67%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>180</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分：（N+P2O5+K2O）≥40%高氯养分配比：17-8-15</td>\n",
       "      <td>尿 素（养分≥46%） (占15%),生化黄腐酸钾 (占8%),磷酸一铵（养分≥58%） (...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>181</td>\n",
       "      <td>有机-无机复混肥料</td>\n",
       "      <td>总养分≥30%（15-6-9）有机质含量≥15%</td>\n",
       "      <td>尿素 (占26.9%),磷酸二铵 (占12%),氯化钾 (占14.2%),发酵滤泥 (占46...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>182</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分≥25.0%（15-5-5）含氯（高氯）枸溶性磷</td>\n",
       "      <td>尿素 (占15%),腐殖酸 (占14.9%),高岭土 (占10%),氯化铵 (占30%),磷...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>183</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥27%（10-5-12）含氯（中氯）、枸溶性磷</td>\n",
       "      <td>尿素 (占10%),高岭土 (占20%),氯化铵 (占22%),肥料级磷酸氢钙 (占8%),...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>184</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总含量≥40.0%（16-8-16）含氯（高氯）枸溶性磷</td>\n",
       "      <td>尿素 (占23.5%),腐殖酸 (占3.9%),高岭土 (占4%),氯化铵 (占15%),磷...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>185</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥28%（11-5-12）含氯（中氯）、枸溶性磷</td>\n",
       "      <td>尿素 (占10%),高岭土 (占16%),氯化铵 (占26%),肥料级磷酸氢钙 (占8%),...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>186</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥35%（17-6-12）含氯（中氯）、水溶性磷</td>\n",
       "      <td>尿素 (占20%),高岭土 (占19%),农用氯化铵 (占28%),粉状磷酸一铵 (占13%...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>187</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥40%(20-8-12)含氯（中氯）、水溶性磷</td>\n",
       "      <td>尿素 (占25%),高岭土 (占8.5%),农用氯化铵 (占29%),粉状磷酸一铵 (占17...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>188</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分(N+P2O5+K2O)≥57％（19―19―19）含氯（低氯）、水溶性磷</td>\n",
       "      <td>尿素 (占25%),高岭土 (占1%),磷酸二铵  (占42%),氯化钾 (占32%)</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>189</td>\n",
       "      <td>掺混肥料</td>\n",
       "      <td>N+P2O5+K2O≥45%(含氯）</td>\n",
       "      <td>46%大颗粒尿素 (占3.38%),64%大颗粒磷酸二铵 (占24.18%),21%大颗粒硫...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.0%</td>\n",
       "      <td>15.0%</td>\n",
       "      <td>15.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>190</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>有机质≥45%，总养分≥5.0%</td>\n",
       "      <td>动物及动物制品 (占99.9%),发酵菌剂 (占0.1%), (占0%), (占0%), (...</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>191</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>有机质≥45.0%N+P2O5+K2O≥12.0%</td>\n",
       "      <td>甘蔗糖蜜酒精发酵废水浓缩醪液 (占99%),石灰浆 (占1%)</td>\n",
       "      <td>45.0%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0%</td>\n",
       "      <td>4.0%</td>\n",
       "      <td>4.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>192</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>有机质≥50%，总养分≥6%</td>\n",
       "      <td>鸡粪 (占84.99%),发酵菌 (占0.01%),酒精渣 (占5%),蔗渣 (占5%),草...</td>\n",
       "      <td>50%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>193</td>\n",
       "      <td>有机-无机复混肥料</td>\n",
       "      <td>规格型号:N+P2O5+K2O≧30%配合式:3-3-24净含量:50㎏硫酸钾型有机质≧20%</td>\n",
       "      <td>硫酸铵 (占12%),酒精浓缩液 (占23%),磷酸一铵 (占7%),氧化镁 (占3.8%)...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>194</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>有机质≥50%，总养分≥6%</td>\n",
       "      <td>鸡粪 (占84.99%),发酵菌 (占0.01%),酒精渣 (占5%),蔗渣 (占5%),草...</td>\n",
       "      <td>50%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>195</td>\n",
       "      <td>有机-无机复混肥料</td>\n",
       "      <td>N-P2O5-K2O≥15%（12-0-3）（含氯）有机质≥20%</td>\n",
       "      <td>硫酸铵 (占60%),氯化钾 (占5%),米糟 (占30%),木薯渣 (占5%), (占0%...</td>\n",
       "      <td>20%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>196</td>\n",
       "      <td>有机-无机复混肥料</td>\n",
       "      <td>有机-无机肥复混肥料（Ⅰ型）6-8-6（含氯）总含量：N+P2O5+K2O≥20%，有机质≥20%</td>\n",
       "      <td>尿素 (占5%),膨润土 (占25%),氯化铵 (占10%),氯化钾 (占10%),磷酸一铵...</td>\n",
       "      <td>20%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.67%</td>\n",
       "      <td>6.67%</td>\n",
       "      <td>6.67%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>197</td>\n",
       "      <td>有机-无机复混肥料</td>\n",
       "      <td>总养份≥29％（9-7-13）有机质≥20％含氯</td>\n",
       "      <td>尿素 (占16.5%),酒糟 (占13%),滤泥 (占33.2%),磷酸一铵 (占15.6%...</td>\n",
       "      <td>20%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>198</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>总养分(N+P2O5+K2O)≥5.0％有机质≥45％酸碱度（PH）5.5∽8.5</td>\n",
       "      <td>畜禽粪便 (占50%),菌种 (占2%),桐 麸 (占30%),滤泥 (占18%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>199</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥5.0%有机质≥45%</td>\n",
       "      <td>牛粪 (占85%),发酵剂 (占0.03%),鸡粪 (占10%), (占0%), (占0%)...</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>200</td>\n",
       "      <td>有机-无机复混肥料</td>\n",
       "      <td>总养分≥25%（N+P2O5+K2O）有机质≥15%含氯II型</td>\n",
       "      <td>尿素 (占26%),高岭土 (占10%),55磷酸一铵 (占12%),氯化钾 (占12%),...</td>\n",
       "      <td>15%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      序号     产品通用名称                                               技术指标  \\\n",
       "0      1       复混肥料                   总养分（N+P2O5+K2O）≥35%（14-8-13）硫酸钾型   \n",
       "1      2       复混肥料                      总养分（N+P2O5+K2O）≥30%（15-6-9）中氯   \n",
       "2      3       有机肥料                              N+P2O5+K2O≥5%,有机质≥45%   \n",
       "3      4       复混肥料                总养分(N+P2O5+K2O)≥43％（10―18―15）含氯（低氯）   \n",
       "4      5       有机肥料          总养分(N+P2O5+K2O)≥5.0％有机质≥45％酸碱度（PH）5.5∽8.5   \n",
       "5      6  有机-无机复混肥料               总养分(N+P2O5+K2O)≥20％（10―4―6）有机质≥20％含氯   \n",
       "6      7       有机肥料                         总养分（N+P2O5+K2O）≥5%，有机质≥45%   \n",
       "7      8       有机肥料           N+P2O5+K2O≥6%有机质≥50%水分≤30%酸碱度（pH）5.5—8.5   \n",
       "8      9       有机肥料           N+P2O5+K2O≥7%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5   \n",
       "9     10       有机肥料           N+P2O5+K2O≥7%有机质≥55%水分≤30%酸碱度（pH）5.5—8.5   \n",
       "10    11       有机肥料           N+P2O5+K2O≥9%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5   \n",
       "11    12       有机肥料          N+P2O5+K2O≥10%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5   \n",
       "12    13       复混肥料                          N+P2O5+K2O≥35%（15-8-12）高氯   \n",
       "13    14       有机肥料          N+P2O5+K2O≥10%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5   \n",
       "14    15       有机肥料          N+P2O5+K2O≥11%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5   \n",
       "15    16       有机肥料          N+P2O5+K2O≥12%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5   \n",
       "16    17       复混肥料                          N+P2O5+K2O≥30%（12-8-10）高氯   \n",
       "17    18       复混肥料                           N+P2O5+K2O≥30%（14-7-9）高氯   \n",
       "18    19       复混肥料                        N+P2O5+K2O≥40%（17-8-15）硫酸钾型   \n",
       "19    20       复混肥料                     N+P2O5+K2O≥46%（15-13-18）含氯（高氯）   \n",
       "20    21       复混肥料                     N+P2O5+K2O≥30%，（16-6-8），含氯（低氯）   \n",
       "21    22       有机肥料                        总养分（N+P2O5+K2O）≥5.0%有机质≥45%   \n",
       "22    23       有机肥料                                  有机质的质量分数（以烘干基计），%   \n",
       "23    24       有机肥料                              N+P2O5+K2O≥5%，有机质≥45%   \n",
       "24    25       复混肥料                        N+P2O5+K2O≥38%（12-8-18）硫酸钾型   \n",
       "25    26  有机-无机复混肥料                      1、养分（N+P2O5+K2O）≥25%2、有机质≥15%   \n",
       "26    27       有机肥料                              N+P2O5+K2O≥12%有机质≥45%   \n",
       "27    28       复混肥料               总养分（N+P2O5+K2O）≥40%（17-7-16）硫酸钾型含硝态氮   \n",
       "28    29       有机肥料                                总养分≥5.0%有机质≧45%含氯：0   \n",
       "29    30       有机肥料                        总养分(N+P2O5+K2O)≥5.0%有机质≥45%   \n",
       "..   ...        ...                                                ...   \n",
       "170  171       复混肥料                                总养分(N+P2o5+K2O)≥30%   \n",
       "171  172       掺混肥料                                总养分(N+P2o5+K2O)≥48%   \n",
       "172  173       复混肥料                       总养分≥40.0%（18-7-15）含氯（高氯）枸溶性磷   \n",
       "173  174       复混肥料                                 2017-08-1500:00:00   \n",
       "174  175       复混肥料              总养分（N+P2O5+K2O）≥33%含氯（中氯）养分配比：17-6-10   \n",
       "175  176       复混肥料                  总养分（N+P2O5+K2O）≥35%中氯养分配比：18-7-10   \n",
       "176  177       有机肥料                                 总养份≥45%，有机质≥60%不含氯   \n",
       "177  178  有机-无机复混肥料                 N+P2O5+K2O≥30%（15-5-10），有机质≥15%，含氯   \n",
       "178  179       有机肥料                               N+P2O5+K2O≥5%有机质≥45%   \n",
       "179  180       复混肥料                 总养分：（N+P2O5+K2O）≥40%高氯养分配比：17-8-15   \n",
       "180  181  有机-无机复混肥料                           总养分≥30%（15-6-9）有机质含量≥15%   \n",
       "181  182       复混肥料                        总养分≥25.0%（15-5-5）含氯（高氯）枸溶性磷   \n",
       "182  183       复混肥料            总养分（N+P2O5+K2O）≥27%（10-5-12）含氯（中氯）、枸溶性磷   \n",
       "183  184       复混肥料                       总含量≥40.0%（16-8-16）含氯（高氯）枸溶性磷   \n",
       "184  185       复混肥料            总养分（N+P2O5+K2O）≥28%（11-5-12）含氯（中氯）、枸溶性磷   \n",
       "185  186       复混肥料            总养分（N+P2O5+K2O）≥35%（17-6-12）含氯（中氯）、水溶性磷   \n",
       "186  187       复混肥料            总养分（N+P2O5+K2O）≥40%(20-8-12)含氯（中氯）、水溶性磷   \n",
       "187  188       复混肥料           总养分(N+P2O5+K2O)≥57％（19―19―19）含氯（低氯）、水溶性磷   \n",
       "188  189       掺混肥料                                 N+P2O5+K2O≥45%(含氯）   \n",
       "189  190       有机肥料                                   有机质≥45%，总养分≥5.0%   \n",
       "190  191       有机肥料                          有机质≥45.0%N+P2O5+K2O≥12.0%   \n",
       "191  192       有机肥料                                     有机质≥50%，总养分≥6%   \n",
       "192  193  有机-无机复混肥料    规格型号:N+P2O5+K2O≧30%配合式:3-3-24净含量:50㎏硫酸钾型有机质≧20%   \n",
       "193  194       有机肥料                                     有机质≥50%，总养分≥6%   \n",
       "194  195  有机-无机复混肥料                  N-P2O5-K2O≥15%（12-0-3）（含氯）有机质≥20%   \n",
       "195  196  有机-无机复混肥料  有机-无机肥复混肥料（Ⅰ型）6-8-6（含氯）总含量：N+P2O5+K2O≥20%，有机质≥20%   \n",
       "196  197  有机-无机复混肥料                           总养份≥29％（9-7-13）有机质≥20％含氯   \n",
       "197  198       有机肥料          总养分(N+P2O5+K2O)≥5.0％有机质≥45％酸碱度（PH）5.5∽8.5   \n",
       "198  199       有机肥料                        总养分（N+P2O5+K2O）≥5.0%有机质≥45%   \n",
       "199  200  有机-无机复混肥料                    总养分≥25%（N+P2O5+K2O）有机质≥15%含氯II型   \n",
       "\n",
       "                                                 原料与占比 有机质百分比  含氯情况   总氮百分比  \\\n",
       "0    尿素 (占15%),高岭土 (占15.5%),硫酸铵 (占28.16%),磷酸一铵 (占16...     0%   0.0     NaN   \n",
       "1    尿素 (占15%),高岭土 (占30.23%),氯化铵 (占28%),磷酸一铵 (占12.2...     0%   NaN     NaN   \n",
       "2               木薯渣（干基） (占84.9%),菌种 (占0.1%),黄豆渣 (占15%)    45%   0.0   1.67%   \n",
       "3        尿素 (占15%),高岭土 (占20%),粉状磷酸一铵 (占40%),氯化钾 (占25%)     0%   NaN     NaN   \n",
       "4           畜禽粪便 (占50%),菌种 (占2%),桐 麸 (占30%),滤 泥 (占18%)    45%   0.0     NaN   \n",
       "5    尿素 (占10%),氯化铵 (占22%),肥料级磷酸氢钙 (占20%),氯化钾 (占10%)...    20%   NaN     NaN   \n",
       "6    甘蔗制糖滤泥 (占85%),复合发酵菌 (占0.05%),米糠 (占10%),酒精发酵浓缩液...    45%   0.0     NaN   \n",
       "7               滤泥 (占78.4%),发酵菌剂 (占0.1%),酒精废液 (占21.5%)    50%   0.0    2.0%   \n",
       "8               滤泥 (占78.6%),发酵菌剂 (占0.1%),酒精废液 (占21.3%)    45%   0.0   2.33%   \n",
       "9                 滤泥 (占77.9%),发酵菌剂 (占0.1%),酒精废液 (占22%)    55%   0.0   2.33%   \n",
       "10              滤泥 (占76.6%),发酵菌剂 (占0.1%),酒精废液 (占23.3%)    45%   0.0    3.0%   \n",
       "11              滤泥 (占75.6%),发酵菌剂 (占0.1%),酒精废液 (占24.3%)    45%   0.0   3.33%   \n",
       "12   尿素 (占14.9%),高岭土 (占15%),硫酸铵 (占32.6%),磷酸一铵  (占17...     0%   NaN  11.67%   \n",
       "13              滤泥 (占75.6%),发酵菌剂 (占0.1%),酒精废液 (占24.3%)    45%   0.0   3.33%   \n",
       "14              滤泥 (占75.8%),发酵菌剂 (占0.1%),酒精废液 (占24.1%)    45%   0.0   3.67%   \n",
       "15              滤泥 (占73.6%),发酵菌剂 (占0.1%),酒精废液 (占26.3%)    45%   0.0    4.0%   \n",
       "16   尿素 (占4.5%),高岭土 (占20%),硫酸铵 (占41.2%),磷酸一铵  (占17....     0%   NaN   10.0%   \n",
       "17   尿素 (占10.2%),高岭土 (占20%),硫酸铵 (占39.2%),磷酸一铵  (占15...     0%   NaN   10.0%   \n",
       "18   尿素 (占27.2%),高岭土 (占10%),硫酸铵 (占15.1%),磷酸一铵  (占17...     0%   0.0  13.33%   \n",
       "19   尿素 (占23.3%),高岭土 (占10%),硫酸铵 (占9.1%),磷酸一铵  (占28....     0%   NaN  15.33%   \n",
       "20      尿素 (占32.5%),磷酸一铵 (占12%),氯化钾 (占13.5%),钙粉 (占42%)     0%   NaN   10.0%   \n",
       "21        滤泥 (占50%),发酵菌 (占0.1%),木薯渣 (占9.9%),甘蔗渣 (占40%)    45%   0.0     NaN   \n",
       "22                   ≥45总养分（氮+五氧化二磷+氧化钾）的质量分数（以烘干基计），%    NaN   0.0     NaN   \n",
       "23   甘蔗滤泥 (占25%), (占0%),烟末、烟梗  (占30%),茶麸米糠  (占45%),...    45%   0.0   1.67%   \n",
       "24   尿素 (占12.2%),高岭土 (占10%),硫酸铵 (占24.2%),磷酸一铵  (占17...     0%   0.0  12.67%   \n",
       "25   虑泥 (占25.5%),发酵菌剂 (占0.5%),酒精渣 (占10%),糖蜜浓缩废液 (占1...    15%   0.0     NaN   \n",
       "26   鸡粪 (占50%),发酵菌剂 (占0.1%),骨粉 (占10%),烟粉 (占10%),糖蜜 ...    45%   0.0    4.0%   \n",
       "27   46%尿素 (占23%),高岭土 (占13%),55%磷酸一铵 (占14.5%),50%硫酸...     0%   0.0     NaN   \n",
       "28             滤泥 (占60%),发酵菌 (占1%),烟粉 (占20%),桐麸 (占19%)    NaN   NaN     NaN   \n",
       "29    罗汉果渣 (占50%),发酵菌（生物菌） (占1%),烟粉 (占25%),糖厂滤泥 (占24%)    45%   0.0     NaN   \n",
       "..                                                 ...    ...   ...     ...   \n",
       "170      尿素 (占35.5%),高岭土 (占21%),氯化铵 (占35%),氯化钾 (占8.5%)     0%   0.0     NaN   \n",
       "171  尿素 (占20.5%),磷酸二铵 (占17.5%),30%氮钾肥 (占31%),氯化钾 (占...    NaN   0.0     NaN   \n",
       "172  尿素 (占21.5%),腐殖酸 (占2.25%),高岭土 (占2.94%),氯化铵 (占26...     0%   NaN     NaN   \n",
       "173  尿素（养分≥46%） (占15.2%),生化黄腐酸钾 (占4.2%),硫酸钾（养分≥52%）...     0%   0.0     NaN   \n",
       "174  尿 素（养分≥46%） (占4.4%),生化黄腐酸钾 (占3%),磷酸一铵（养分≥58%） ...     0%   NaN     NaN   \n",
       "175  尿 素（养分≥46%） (占17%),生化黄腐酸钾 (占7.9%),磷酸一铵（养分≥58%）...     0%   NaN     NaN   \n",
       "176        罗汉果渣 (占79.9%),发酵菌剂 (占0.1%), (占0%),酒糟 (占20%)    60%   NaN     NaN   \n",
       "177  尿素 (占15%),高岭土 (占9%),氯化铵 (占12%),硫酸铵 (占20%),58%磷...    15%   NaN   10.0%   \n",
       "178                     泥炭土 (占40%),米糠 (占20%),蔗渣 (占40%)    45%   0.0   1.67%   \n",
       "179  尿 素（养分≥46%） (占15%),生化黄腐酸钾 (占8%),磷酸一铵（养分≥58%） (...     0%   NaN     NaN   \n",
       "180  尿素 (占26.9%),磷酸二铵 (占12%),氯化钾 (占14.2%),发酵滤泥 (占46...    NaN   0.0     NaN   \n",
       "181  尿素 (占15%),腐殖酸 (占14.9%),高岭土 (占10%),氯化铵 (占30%),磷...     0%   NaN     NaN   \n",
       "182  尿素 (占10%),高岭土 (占20%),氯化铵 (占22%),肥料级磷酸氢钙 (占8%),...     0%   NaN     NaN   \n",
       "183  尿素 (占23.5%),腐殖酸 (占3.9%),高岭土 (占4%),氯化铵 (占15%),磷...     0%   NaN     NaN   \n",
       "184  尿素 (占10%),高岭土 (占16%),氯化铵 (占26%),肥料级磷酸氢钙 (占8%),...     0%   NaN     NaN   \n",
       "185  尿素 (占20%),高岭土 (占19%),农用氯化铵 (占28%),粉状磷酸一铵 (占13%...     0%   NaN     NaN   \n",
       "186  尿素 (占25%),高岭土 (占8.5%),农用氯化铵 (占29%),粉状磷酸一铵 (占17...     0%   NaN     NaN   \n",
       "187        尿素 (占25%),高岭土 (占1%),磷酸二铵  (占42%),氯化钾 (占32%)     0%   NaN     NaN   \n",
       "188  46%大颗粒尿素 (占3.38%),64%大颗粒磷酸二铵 (占24.18%),21%大颗粒硫...    NaN   NaN   15.0%   \n",
       "189  动物及动物制品 (占99.9%),发酵菌剂 (占0.1%), (占0%), (占0%), (...    45%   0.0     NaN   \n",
       "190                    甘蔗糖蜜酒精发酵废水浓缩醪液 (占99%),石灰浆 (占1%)  45.0%   0.0    4.0%   \n",
       "191  鸡粪 (占84.99%),发酵菌 (占0.01%),酒精渣 (占5%),蔗渣 (占5%),草...    50%   0.0     NaN   \n",
       "192  硫酸铵 (占12%),酒精浓缩液 (占23%),磷酸一铵 (占7%),氧化镁 (占3.8%)...    NaN   0.0     NaN   \n",
       "193  鸡粪 (占84.99%),发酵菌 (占0.01%),酒精渣 (占5%),蔗渣 (占5%),草...    50%   0.0     NaN   \n",
       "194  硫酸铵 (占60%),氯化钾 (占5%),米糟 (占30%),木薯渣 (占5%), (占0%...    20%   NaN     NaN   \n",
       "195  尿素 (占5%),膨润土 (占25%),氯化铵 (占10%),氯化钾 (占10%),磷酸一铵...    20%   NaN   6.67%   \n",
       "196  尿素 (占16.5%),酒糟 (占13%),滤泥 (占33.2%),磷酸一铵 (占15.6%...    20%   NaN     NaN   \n",
       "197          畜禽粪便 (占50%),菌种 (占2%),桐 麸 (占30%),滤泥 (占18%)    45%   0.0     NaN   \n",
       "198  牛粪 (占85%),发酵剂 (占0.03%),鸡粪 (占10%), (占0%), (占0%)...    45%   0.0     NaN   \n",
       "199  尿素 (占26%),高岭土 (占10%),55磷酸一铵 (占12%),氯化钾 (占12%),...    15%   NaN     NaN   \n",
       "\n",
       "    P2O5百分比  K2O百分比  \n",
       "0       NaN     NaN  \n",
       "1       NaN     NaN  \n",
       "2     1.67%   1.67%  \n",
       "3       NaN     NaN  \n",
       "4       NaN     NaN  \n",
       "5       NaN     NaN  \n",
       "6       NaN     NaN  \n",
       "7      2.0%    2.0%  \n",
       "8     2.33%   2.33%  \n",
       "9     2.33%   2.33%  \n",
       "10     3.0%    3.0%  \n",
       "11    3.33%   3.33%  \n",
       "12   11.67%  11.67%  \n",
       "13    3.33%   3.33%  \n",
       "14    3.67%   3.67%  \n",
       "15     4.0%    4.0%  \n",
       "16    10.0%   10.0%  \n",
       "17    10.0%   10.0%  \n",
       "18   13.33%  13.33%  \n",
       "19   15.33%  15.33%  \n",
       "20    10.0%   10.0%  \n",
       "21      NaN     NaN  \n",
       "22      NaN     NaN  \n",
       "23    1.67%   1.67%  \n",
       "24   12.67%  12.67%  \n",
       "25      NaN     NaN  \n",
       "26     4.0%    4.0%  \n",
       "27      NaN     NaN  \n",
       "28      NaN     NaN  \n",
       "29      NaN     NaN  \n",
       "..      ...     ...  \n",
       "170     NaN     NaN  \n",
       "171     NaN     NaN  \n",
       "172     NaN     NaN  \n",
       "173     NaN     NaN  \n",
       "174     NaN     NaN  \n",
       "175     NaN     NaN  \n",
       "176     NaN     NaN  \n",
       "177   10.0%   10.0%  \n",
       "178   1.67%   1.67%  \n",
       "179     NaN     NaN  \n",
       "180     NaN     NaN  \n",
       "181     NaN     NaN  \n",
       "182     NaN     NaN  \n",
       "183     NaN     NaN  \n",
       "184     NaN     NaN  \n",
       "185     NaN     NaN  \n",
       "186     NaN     NaN  \n",
       "187     NaN     NaN  \n",
       "188   15.0%   15.0%  \n",
       "189     NaN     NaN  \n",
       "190    4.0%    4.0%  \n",
       "191     NaN     NaN  \n",
       "192     NaN     NaN  \n",
       "193     NaN     NaN  \n",
       "194     NaN     NaN  \n",
       "195   6.67%   6.67%  \n",
       "196     NaN     NaN  \n",
       "197     NaN     NaN  \n",
       "198     NaN     NaN  \n",
       "199     NaN     NaN  \n",
       "\n",
       "[200 rows x 9 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result4_1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 处理含氯指标为0的情况\n",
    "for x in list(data.index):\n",
    "    i = data.loc[x]['序号']\n",
    "    if ('氯' in data.loc[x]['技术指标']) == False:\n",
    "        result4_1.loc[result4_1['序号']==i,'含氯情况'] = 0\n",
    "result4_1.to_excel('data/result4_1.xlsx',encoding='gbk')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>序号</th>\n",
       "      <th>产品通用名称</th>\n",
       "      <th>技术指标</th>\n",
       "      <th>原料与占比</th>\n",
       "      <th>有机质百分比</th>\n",
       "      <th>含氯情况</th>\n",
       "      <th>总氮百分比</th>\n",
       "      <th>P2O5百分比</th>\n",
       "      <th>K2O百分比</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥35%（14-8-13）硫酸钾型</td>\n",
       "      <td>尿素 (占15%),高岭土 (占15.5%),硫酸铵 (占28.16%),磷酸一铵 (占16...</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥30%（15-6-9）中氯</td>\n",
       "      <td>尿素 (占15%),高岭土 (占30.23%),氯化铵 (占28%),磷酸一铵 (占12.2...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥5%,有机质≥45%</td>\n",
       "      <td>木薯渣（干基） (占84.9%),菌种 (占0.1%),黄豆渣 (占15%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.67%</td>\n",
       "      <td>1.67%</td>\n",
       "      <td>1.67%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分(N+P2O5+K2O)≥43％（10―18―15）含氯（低氯）</td>\n",
       "      <td>尿素 (占15%),高岭土 (占20%),粉状磷酸一铵 (占40%),氯化钾 (占25%)</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>总养分(N+P2O5+K2O)≥5.0％有机质≥45％酸碱度（PH）5.5∽8.5</td>\n",
       "      <td>畜禽粪便 (占50%),菌种 (占2%),桐 麸 (占30%),滤 泥 (占18%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>有机-无机复混肥料</td>\n",
       "      <td>总养分(N+P2O5+K2O)≥20％（10―4―6）有机质≥20％含氯</td>\n",
       "      <td>尿素 (占10%),氯化铵 (占22%),肥料级磷酸氢钙 (占20%),氯化钾 (占10%)...</td>\n",
       "      <td>20%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥5%，有机质≥45%</td>\n",
       "      <td>甘蔗制糖滤泥 (占85%),复合发酵菌 (占0.05%),米糠 (占10%),酒精发酵浓缩液...</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥6%有机质≥50%水分≤30%酸碱度（pH）5.5—8.5</td>\n",
       "      <td>滤泥 (占78.4%),发酵菌剂 (占0.1%),酒精废液 (占21.5%)</td>\n",
       "      <td>50%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0%</td>\n",
       "      <td>2.0%</td>\n",
       "      <td>2.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥7%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5</td>\n",
       "      <td>滤泥 (占78.6%),发酵菌剂 (占0.1%),酒精废液 (占21.3%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.33%</td>\n",
       "      <td>2.33%</td>\n",
       "      <td>2.33%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥7%有机质≥55%水分≤30%酸碱度（pH）5.5—8.5</td>\n",
       "      <td>滤泥 (占77.9%),发酵菌剂 (占0.1%),酒精废液 (占22%)</td>\n",
       "      <td>55%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.33%</td>\n",
       "      <td>2.33%</td>\n",
       "      <td>2.33%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥9%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5</td>\n",
       "      <td>滤泥 (占76.6%),发酵菌剂 (占0.1%),酒精废液 (占23.3%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0%</td>\n",
       "      <td>3.0%</td>\n",
       "      <td>3.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥10%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5</td>\n",
       "      <td>滤泥 (占75.6%),发酵菌剂 (占0.1%),酒精废液 (占24.3%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.33%</td>\n",
       "      <td>3.33%</td>\n",
       "      <td>3.33%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>N+P2O5+K2O≥35%（15-8-12）高氯</td>\n",
       "      <td>尿素 (占14.9%),高岭土 (占15%),硫酸铵 (占32.6%),磷酸一铵  (占17...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.67%</td>\n",
       "      <td>11.67%</td>\n",
       "      <td>11.67%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥10%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5</td>\n",
       "      <td>滤泥 (占75.6%),发酵菌剂 (占0.1%),酒精废液 (占24.3%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.33%</td>\n",
       "      <td>3.33%</td>\n",
       "      <td>3.33%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥11%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5</td>\n",
       "      <td>滤泥 (占75.8%),发酵菌剂 (占0.1%),酒精废液 (占24.1%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.67%</td>\n",
       "      <td>3.67%</td>\n",
       "      <td>3.67%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥12%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5</td>\n",
       "      <td>滤泥 (占73.6%),发酵菌剂 (占0.1%),酒精废液 (占26.3%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0%</td>\n",
       "      <td>4.0%</td>\n",
       "      <td>4.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>N+P2O5+K2O≥30%（12-8-10）高氯</td>\n",
       "      <td>尿素 (占4.5%),高岭土 (占20%),硫酸铵 (占41.2%),磷酸一铵  (占17....</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0%</td>\n",
       "      <td>10.0%</td>\n",
       "      <td>10.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>N+P2O5+K2O≥30%（14-7-9）高氯</td>\n",
       "      <td>尿素 (占10.2%),高岭土 (占20%),硫酸铵 (占39.2%),磷酸一铵  (占15...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0%</td>\n",
       "      <td>10.0%</td>\n",
       "      <td>10.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>N+P2O5+K2O≥40%（17-8-15）硫酸钾型</td>\n",
       "      <td>尿素 (占27.2%),高岭土 (占10%),硫酸铵 (占15.1%),磷酸一铵  (占17...</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13.33%</td>\n",
       "      <td>13.33%</td>\n",
       "      <td>13.33%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>N+P2O5+K2O≥46%（15-13-18）含氯（高氯）</td>\n",
       "      <td>尿素 (占23.3%),高岭土 (占10%),硫酸铵 (占9.1%),磷酸一铵  (占28....</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.33%</td>\n",
       "      <td>15.33%</td>\n",
       "      <td>15.33%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>N+P2O5+K2O≥30%，（16-6-8），含氯（低氯）</td>\n",
       "      <td>尿素 (占32.5%),磷酸一铵 (占12%),氯化钾 (占13.5%),钙粉 (占42%)</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0%</td>\n",
       "      <td>10.0%</td>\n",
       "      <td>10.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥5.0%有机质≥45%</td>\n",
       "      <td>滤泥 (占50%),发酵菌 (占0.1%),木薯渣 (占9.9%),甘蔗渣 (占40%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>有机质的质量分数（以烘干基计），%</td>\n",
       "      <td>≥45总养分（氮+五氧化二磷+氧化钾）的质量分数（以烘干基计），%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥5%，有机质≥45%</td>\n",
       "      <td>甘蔗滤泥 (占25%), (占0%),烟末、烟梗  (占30%),茶麸米糠  (占45%),...</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.67%</td>\n",
       "      <td>1.67%</td>\n",
       "      <td>1.67%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>N+P2O5+K2O≥38%（12-8-18）硫酸钾型</td>\n",
       "      <td>尿素 (占12.2%),高岭土 (占10%),硫酸铵 (占24.2%),磷酸一铵  (占17...</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12.67%</td>\n",
       "      <td>12.67%</td>\n",
       "      <td>12.67%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>有机-无机复混肥料</td>\n",
       "      <td>1、养分（N+P2O5+K2O）≥25%2、有机质≥15%</td>\n",
       "      <td>虑泥 (占25.5%),发酵菌剂 (占0.5%),酒精渣 (占10%),糖蜜浓缩废液 (占1...</td>\n",
       "      <td>15%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥12%有机质≥45%</td>\n",
       "      <td>鸡粪 (占50%),发酵菌剂 (占0.1%),骨粉 (占10%),烟粉 (占10%),糖蜜 ...</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0%</td>\n",
       "      <td>4.0%</td>\n",
       "      <td>4.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥40%（17-7-16）硫酸钾型含硝态氮</td>\n",
       "      <td>46%尿素 (占23%),高岭土 (占13%),55%磷酸一铵 (占14.5%),50%硫酸...</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>总养分≥5.0%有机质≧45%含氯：0</td>\n",
       "      <td>滤泥 (占60%),发酵菌 (占1%),烟粉 (占20%),桐麸 (占19%)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>总养分(N+P2O5+K2O)≥5.0%有机质≥45%</td>\n",
       "      <td>罗汉果渣 (占50%),发酵菌（生物菌） (占1%),烟粉 (占25%),糖厂滤泥 (占24%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>171</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分(N+P2o5+K2O)≥30%</td>\n",
       "      <td>尿素 (占35.5%),高岭土 (占21%),氯化铵 (占35%),氯化钾 (占8.5%)</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>172</td>\n",
       "      <td>掺混肥料</td>\n",
       "      <td>总养分(N+P2o5+K2O)≥48%</td>\n",
       "      <td>尿素 (占20.5%),磷酸二铵 (占17.5%),30%氮钾肥 (占31%),氯化钾 (占...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>173</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分≥40.0%（18-7-15）含氯（高氯）枸溶性磷</td>\n",
       "      <td>尿素 (占21.5%),腐殖酸 (占2.25%),高岭土 (占2.94%),氯化铵 (占26...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>174</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>2017-08-1500:00:00</td>\n",
       "      <td>尿素（养分≥46%） (占15.2%),生化黄腐酸钾 (占4.2%),硫酸钾（养分≥52%）...</td>\n",
       "      <td>0%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>175</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥33%含氯（中氯）养分配比：17-6-10</td>\n",
       "      <td>尿 素（养分≥46%） (占4.4%),生化黄腐酸钾 (占3%),磷酸一铵（养分≥58%） ...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>176</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥35%中氯养分配比：18-7-10</td>\n",
       "      <td>尿 素（养分≥46%） (占17%),生化黄腐酸钾 (占7.9%),磷酸一铵（养分≥58%）...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>177</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>总养份≥45%，有机质≥60%不含氯</td>\n",
       "      <td>罗汉果渣 (占79.9%),发酵菌剂 (占0.1%), (占0%),酒糟 (占20%)</td>\n",
       "      <td>60%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>178</td>\n",
       "      <td>有机-无机复混肥料</td>\n",
       "      <td>N+P2O5+K2O≥30%（15-5-10），有机质≥15%，含氯</td>\n",
       "      <td>尿素 (占15%),高岭土 (占9%),氯化铵 (占12%),硫酸铵 (占20%),58%磷...</td>\n",
       "      <td>15%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0%</td>\n",
       "      <td>10.0%</td>\n",
       "      <td>10.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>179</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥5%有机质≥45%</td>\n",
       "      <td>泥炭土 (占40%),米糠 (占20%),蔗渣 (占40%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.67%</td>\n",
       "      <td>1.67%</td>\n",
       "      <td>1.67%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>180</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分：（N+P2O5+K2O）≥40%高氯养分配比：17-8-15</td>\n",
       "      <td>尿 素（养分≥46%） (占15%),生化黄腐酸钾 (占8%),磷酸一铵（养分≥58%） (...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>181</td>\n",
       "      <td>有机-无机复混肥料</td>\n",
       "      <td>总养分≥30%（15-6-9）有机质含量≥15%</td>\n",
       "      <td>尿素 (占26.9%),磷酸二铵 (占12%),氯化钾 (占14.2%),发酵滤泥 (占46...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>182</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分≥25.0%（15-5-5）含氯（高氯）枸溶性磷</td>\n",
       "      <td>尿素 (占15%),腐殖酸 (占14.9%),高岭土 (占10%),氯化铵 (占30%),磷...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>183</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥27%（10-5-12）含氯（中氯）、枸溶性磷</td>\n",
       "      <td>尿素 (占10%),高岭土 (占20%),氯化铵 (占22%),肥料级磷酸氢钙 (占8%),...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>184</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总含量≥40.0%（16-8-16）含氯（高氯）枸溶性磷</td>\n",
       "      <td>尿素 (占23.5%),腐殖酸 (占3.9%),高岭土 (占4%),氯化铵 (占15%),磷...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>185</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥28%（11-5-12）含氯（中氯）、枸溶性磷</td>\n",
       "      <td>尿素 (占10%),高岭土 (占16%),氯化铵 (占26%),肥料级磷酸氢钙 (占8%),...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>186</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥35%（17-6-12）含氯（中氯）、水溶性磷</td>\n",
       "      <td>尿素 (占20%),高岭土 (占19%),农用氯化铵 (占28%),粉状磷酸一铵 (占13%...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>187</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥40%(20-8-12)含氯（中氯）、水溶性磷</td>\n",
       "      <td>尿素 (占25%),高岭土 (占8.5%),农用氯化铵 (占29%),粉状磷酸一铵 (占17...</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>188</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分(N+P2O5+K2O)≥57％（19―19―19）含氯（低氯）、水溶性磷</td>\n",
       "      <td>尿素 (占25%),高岭土 (占1%),磷酸二铵  (占42%),氯化钾 (占32%)</td>\n",
       "      <td>0%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>189</td>\n",
       "      <td>掺混肥料</td>\n",
       "      <td>N+P2O5+K2O≥45%(含氯）</td>\n",
       "      <td>46%大颗粒尿素 (占3.38%),64%大颗粒磷酸二铵 (占24.18%),21%大颗粒硫...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.0%</td>\n",
       "      <td>15.0%</td>\n",
       "      <td>15.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>190</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>有机质≥45%，总养分≥5.0%</td>\n",
       "      <td>动物及动物制品 (占99.9%),发酵菌剂 (占0.1%), (占0%), (占0%), (...</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>191</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>有机质≥45.0%N+P2O5+K2O≥12.0%</td>\n",
       "      <td>甘蔗糖蜜酒精发酵废水浓缩醪液 (占99%),石灰浆 (占1%)</td>\n",
       "      <td>45.0%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0%</td>\n",
       "      <td>4.0%</td>\n",
       "      <td>4.0%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>192</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>有机质≥50%，总养分≥6%</td>\n",
       "      <td>鸡粪 (占84.99%),发酵菌 (占0.01%),酒精渣 (占5%),蔗渣 (占5%),草...</td>\n",
       "      <td>50%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>193</td>\n",
       "      <td>有机-无机复混肥料</td>\n",
       "      <td>规格型号:N+P2O5+K2O≧30%配合式:3-3-24净含量:50㎏硫酸钾型有机质≧20%</td>\n",
       "      <td>硫酸铵 (占12%),酒精浓缩液 (占23%),磷酸一铵 (占7%),氧化镁 (占3.8%)...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>194</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>有机质≥50%，总养分≥6%</td>\n",
       "      <td>鸡粪 (占84.99%),发酵菌 (占0.01%),酒精渣 (占5%),蔗渣 (占5%),草...</td>\n",
       "      <td>50%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>195</td>\n",
       "      <td>有机-无机复混肥料</td>\n",
       "      <td>N-P2O5-K2O≥15%（12-0-3）（含氯）有机质≥20%</td>\n",
       "      <td>硫酸铵 (占60%),氯化钾 (占5%),米糟 (占30%),木薯渣 (占5%), (占0%...</td>\n",
       "      <td>20%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>196</td>\n",
       "      <td>有机-无机复混肥料</td>\n",
       "      <td>有机-无机肥复混肥料（Ⅰ型）6-8-6（含氯）总含量：N+P2O5+K2O≥20%，有机质≥20%</td>\n",
       "      <td>尿素 (占5%),膨润土 (占25%),氯化铵 (占10%),氯化钾 (占10%),磷酸一铵...</td>\n",
       "      <td>20%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.67%</td>\n",
       "      <td>6.67%</td>\n",
       "      <td>6.67%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>197</td>\n",
       "      <td>有机-无机复混肥料</td>\n",
       "      <td>总养份≥29％（9-7-13）有机质≥20％含氯</td>\n",
       "      <td>尿素 (占16.5%),酒糟 (占13%),滤泥 (占33.2%),磷酸一铵 (占15.6%...</td>\n",
       "      <td>20%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>198</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>总养分(N+P2O5+K2O)≥5.0％有机质≥45％酸碱度（PH）5.5∽8.5</td>\n",
       "      <td>畜禽粪便 (占50%),菌种 (占2%),桐 麸 (占30%),滤泥 (占18%)</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>199</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥5.0%有机质≥45%</td>\n",
       "      <td>牛粪 (占85%),发酵剂 (占0.03%),鸡粪 (占10%), (占0%), (占0%)...</td>\n",
       "      <td>45%</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>200</td>\n",
       "      <td>有机-无机复混肥料</td>\n",
       "      <td>总养分≥25%（N+P2O5+K2O）有机质≥15%含氯II型</td>\n",
       "      <td>尿素 (占26%),高岭土 (占10%),55磷酸一铵 (占12%),氯化钾 (占12%),...</td>\n",
       "      <td>15%</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      序号     产品通用名称                                               技术指标  \\\n",
       "0      1       复混肥料                   总养分（N+P2O5+K2O）≥35%（14-8-13）硫酸钾型   \n",
       "1      2       复混肥料                      总养分（N+P2O5+K2O）≥30%（15-6-9）中氯   \n",
       "2      3       有机肥料                              N+P2O5+K2O≥5%,有机质≥45%   \n",
       "3      4       复混肥料                总养分(N+P2O5+K2O)≥43％（10―18―15）含氯（低氯）   \n",
       "4      5       有机肥料          总养分(N+P2O5+K2O)≥5.0％有机质≥45％酸碱度（PH）5.5∽8.5   \n",
       "5      6  有机-无机复混肥料               总养分(N+P2O5+K2O)≥20％（10―4―6）有机质≥20％含氯   \n",
       "6      7       有机肥料                         总养分（N+P2O5+K2O）≥5%，有机质≥45%   \n",
       "7      8       有机肥料           N+P2O5+K2O≥6%有机质≥50%水分≤30%酸碱度（pH）5.5—8.5   \n",
       "8      9       有机肥料           N+P2O5+K2O≥7%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5   \n",
       "9     10       有机肥料           N+P2O5+K2O≥7%有机质≥55%水分≤30%酸碱度（pH）5.5—8.5   \n",
       "10    11       有机肥料           N+P2O5+K2O≥9%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5   \n",
       "11    12       有机肥料          N+P2O5+K2O≥10%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5   \n",
       "12    13       复混肥料                          N+P2O5+K2O≥35%（15-8-12）高氯   \n",
       "13    14       有机肥料          N+P2O5+K2O≥10%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5   \n",
       "14    15       有机肥料          N+P2O5+K2O≥11%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5   \n",
       "15    16       有机肥料          N+P2O5+K2O≥12%有机质≥45%水分≤30%酸碱度（pH）5.5—8.5   \n",
       "16    17       复混肥料                          N+P2O5+K2O≥30%（12-8-10）高氯   \n",
       "17    18       复混肥料                           N+P2O5+K2O≥30%（14-7-9）高氯   \n",
       "18    19       复混肥料                        N+P2O5+K2O≥40%（17-8-15）硫酸钾型   \n",
       "19    20       复混肥料                     N+P2O5+K2O≥46%（15-13-18）含氯（高氯）   \n",
       "20    21       复混肥料                     N+P2O5+K2O≥30%，（16-6-8），含氯（低氯）   \n",
       "21    22       有机肥料                        总养分（N+P2O5+K2O）≥5.0%有机质≥45%   \n",
       "22    23       有机肥料                                  有机质的质量分数（以烘干基计），%   \n",
       "23    24       有机肥料                              N+P2O5+K2O≥5%，有机质≥45%   \n",
       "24    25       复混肥料                        N+P2O5+K2O≥38%（12-8-18）硫酸钾型   \n",
       "25    26  有机-无机复混肥料                      1、养分（N+P2O5+K2O）≥25%2、有机质≥15%   \n",
       "26    27       有机肥料                              N+P2O5+K2O≥12%有机质≥45%   \n",
       "27    28       复混肥料               总养分（N+P2O5+K2O）≥40%（17-7-16）硫酸钾型含硝态氮   \n",
       "28    29       有机肥料                                总养分≥5.0%有机质≧45%含氯：0   \n",
       "29    30       有机肥料                        总养分(N+P2O5+K2O)≥5.0%有机质≥45%   \n",
       "..   ...        ...                                                ...   \n",
       "170  171       复混肥料                                总养分(N+P2o5+K2O)≥30%   \n",
       "171  172       掺混肥料                                总养分(N+P2o5+K2O)≥48%   \n",
       "172  173       复混肥料                       总养分≥40.0%（18-7-15）含氯（高氯）枸溶性磷   \n",
       "173  174       复混肥料                                 2017-08-1500:00:00   \n",
       "174  175       复混肥料              总养分（N+P2O5+K2O）≥33%含氯（中氯）养分配比：17-6-10   \n",
       "175  176       复混肥料                  总养分（N+P2O5+K2O）≥35%中氯养分配比：18-7-10   \n",
       "176  177       有机肥料                                 总养份≥45%，有机质≥60%不含氯   \n",
       "177  178  有机-无机复混肥料                 N+P2O5+K2O≥30%（15-5-10），有机质≥15%，含氯   \n",
       "178  179       有机肥料                               N+P2O5+K2O≥5%有机质≥45%   \n",
       "179  180       复混肥料                 总养分：（N+P2O5+K2O）≥40%高氯养分配比：17-8-15   \n",
       "180  181  有机-无机复混肥料                           总养分≥30%（15-6-9）有机质含量≥15%   \n",
       "181  182       复混肥料                        总养分≥25.0%（15-5-5）含氯（高氯）枸溶性磷   \n",
       "182  183       复混肥料            总养分（N+P2O5+K2O）≥27%（10-5-12）含氯（中氯）、枸溶性磷   \n",
       "183  184       复混肥料                       总含量≥40.0%（16-8-16）含氯（高氯）枸溶性磷   \n",
       "184  185       复混肥料            总养分（N+P2O5+K2O）≥28%（11-5-12）含氯（中氯）、枸溶性磷   \n",
       "185  186       复混肥料            总养分（N+P2O5+K2O）≥35%（17-6-12）含氯（中氯）、水溶性磷   \n",
       "186  187       复混肥料            总养分（N+P2O5+K2O）≥40%(20-8-12)含氯（中氯）、水溶性磷   \n",
       "187  188       复混肥料           总养分(N+P2O5+K2O)≥57％（19―19―19）含氯（低氯）、水溶性磷   \n",
       "188  189       掺混肥料                                 N+P2O5+K2O≥45%(含氯）   \n",
       "189  190       有机肥料                                   有机质≥45%，总养分≥5.0%   \n",
       "190  191       有机肥料                          有机质≥45.0%N+P2O5+K2O≥12.0%   \n",
       "191  192       有机肥料                                     有机质≥50%，总养分≥6%   \n",
       "192  193  有机-无机复混肥料    规格型号:N+P2O5+K2O≧30%配合式:3-3-24净含量:50㎏硫酸钾型有机质≧20%   \n",
       "193  194       有机肥料                                     有机质≥50%，总养分≥6%   \n",
       "194  195  有机-无机复混肥料                  N-P2O5-K2O≥15%（12-0-3）（含氯）有机质≥20%   \n",
       "195  196  有机-无机复混肥料  有机-无机肥复混肥料（Ⅰ型）6-8-6（含氯）总含量：N+P2O5+K2O≥20%，有机质≥20%   \n",
       "196  197  有机-无机复混肥料                           总养份≥29％（9-7-13）有机质≥20％含氯   \n",
       "197  198       有机肥料          总养分(N+P2O5+K2O)≥5.0％有机质≥45％酸碱度（PH）5.5∽8.5   \n",
       "198  199       有机肥料                        总养分（N+P2O5+K2O）≥5.0%有机质≥45%   \n",
       "199  200  有机-无机复混肥料                    总养分≥25%（N+P2O5+K2O）有机质≥15%含氯II型   \n",
       "\n",
       "                                                 原料与占比 有机质百分比  含氯情况   总氮百分比  \\\n",
       "0    尿素 (占15%),高岭土 (占15.5%),硫酸铵 (占28.16%),磷酸一铵 (占16...     0%   0.0     NaN   \n",
       "1    尿素 (占15%),高岭土 (占30.23%),氯化铵 (占28%),磷酸一铵 (占12.2...     0%   NaN     NaN   \n",
       "2               木薯渣（干基） (占84.9%),菌种 (占0.1%),黄豆渣 (占15%)    45%   0.0   1.67%   \n",
       "3        尿素 (占15%),高岭土 (占20%),粉状磷酸一铵 (占40%),氯化钾 (占25%)     0%   NaN     NaN   \n",
       "4           畜禽粪便 (占50%),菌种 (占2%),桐 麸 (占30%),滤 泥 (占18%)    45%   0.0     NaN   \n",
       "5    尿素 (占10%),氯化铵 (占22%),肥料级磷酸氢钙 (占20%),氯化钾 (占10%)...    20%   NaN     NaN   \n",
       "6    甘蔗制糖滤泥 (占85%),复合发酵菌 (占0.05%),米糠 (占10%),酒精发酵浓缩液...    45%   0.0     NaN   \n",
       "7               滤泥 (占78.4%),发酵菌剂 (占0.1%),酒精废液 (占21.5%)    50%   0.0    2.0%   \n",
       "8               滤泥 (占78.6%),发酵菌剂 (占0.1%),酒精废液 (占21.3%)    45%   0.0   2.33%   \n",
       "9                 滤泥 (占77.9%),发酵菌剂 (占0.1%),酒精废液 (占22%)    55%   0.0   2.33%   \n",
       "10              滤泥 (占76.6%),发酵菌剂 (占0.1%),酒精废液 (占23.3%)    45%   0.0    3.0%   \n",
       "11              滤泥 (占75.6%),发酵菌剂 (占0.1%),酒精废液 (占24.3%)    45%   0.0   3.33%   \n",
       "12   尿素 (占14.9%),高岭土 (占15%),硫酸铵 (占32.6%),磷酸一铵  (占17...     0%   NaN  11.67%   \n",
       "13              滤泥 (占75.6%),发酵菌剂 (占0.1%),酒精废液 (占24.3%)    45%   0.0   3.33%   \n",
       "14              滤泥 (占75.8%),发酵菌剂 (占0.1%),酒精废液 (占24.1%)    45%   0.0   3.67%   \n",
       "15              滤泥 (占73.6%),发酵菌剂 (占0.1%),酒精废液 (占26.3%)    45%   0.0    4.0%   \n",
       "16   尿素 (占4.5%),高岭土 (占20%),硫酸铵 (占41.2%),磷酸一铵  (占17....     0%   NaN   10.0%   \n",
       "17   尿素 (占10.2%),高岭土 (占20%),硫酸铵 (占39.2%),磷酸一铵  (占15...     0%   NaN   10.0%   \n",
       "18   尿素 (占27.2%),高岭土 (占10%),硫酸铵 (占15.1%),磷酸一铵  (占17...     0%   0.0  13.33%   \n",
       "19   尿素 (占23.3%),高岭土 (占10%),硫酸铵 (占9.1%),磷酸一铵  (占28....     0%   NaN  15.33%   \n",
       "20      尿素 (占32.5%),磷酸一铵 (占12%),氯化钾 (占13.5%),钙粉 (占42%)     0%   NaN   10.0%   \n",
       "21        滤泥 (占50%),发酵菌 (占0.1%),木薯渣 (占9.9%),甘蔗渣 (占40%)    45%   0.0     NaN   \n",
       "22                   ≥45总养分（氮+五氧化二磷+氧化钾）的质量分数（以烘干基计），%    NaN   0.0     NaN   \n",
       "23   甘蔗滤泥 (占25%), (占0%),烟末、烟梗  (占30%),茶麸米糠  (占45%),...    45%   0.0   1.67%   \n",
       "24   尿素 (占12.2%),高岭土 (占10%),硫酸铵 (占24.2%),磷酸一铵  (占17...     0%   0.0  12.67%   \n",
       "25   虑泥 (占25.5%),发酵菌剂 (占0.5%),酒精渣 (占10%),糖蜜浓缩废液 (占1...    15%   0.0     NaN   \n",
       "26   鸡粪 (占50%),发酵菌剂 (占0.1%),骨粉 (占10%),烟粉 (占10%),糖蜜 ...    45%   0.0    4.0%   \n",
       "27   46%尿素 (占23%),高岭土 (占13%),55%磷酸一铵 (占14.5%),50%硫酸...     0%   0.0     NaN   \n",
       "28             滤泥 (占60%),发酵菌 (占1%),烟粉 (占20%),桐麸 (占19%)    NaN   NaN     NaN   \n",
       "29    罗汉果渣 (占50%),发酵菌（生物菌） (占1%),烟粉 (占25%),糖厂滤泥 (占24%)    45%   0.0     NaN   \n",
       "..                                                 ...    ...   ...     ...   \n",
       "170      尿素 (占35.5%),高岭土 (占21%),氯化铵 (占35%),氯化钾 (占8.5%)     0%   0.0     NaN   \n",
       "171  尿素 (占20.5%),磷酸二铵 (占17.5%),30%氮钾肥 (占31%),氯化钾 (占...    NaN   0.0     NaN   \n",
       "172  尿素 (占21.5%),腐殖酸 (占2.25%),高岭土 (占2.94%),氯化铵 (占26...     0%   NaN     NaN   \n",
       "173  尿素（养分≥46%） (占15.2%),生化黄腐酸钾 (占4.2%),硫酸钾（养分≥52%）...     0%   0.0     NaN   \n",
       "174  尿 素（养分≥46%） (占4.4%),生化黄腐酸钾 (占3%),磷酸一铵（养分≥58%） ...     0%   NaN     NaN   \n",
       "175  尿 素（养分≥46%） (占17%),生化黄腐酸钾 (占7.9%),磷酸一铵（养分≥58%）...     0%   NaN     NaN   \n",
       "176        罗汉果渣 (占79.9%),发酵菌剂 (占0.1%), (占0%),酒糟 (占20%)    60%   NaN     NaN   \n",
       "177  尿素 (占15%),高岭土 (占9%),氯化铵 (占12%),硫酸铵 (占20%),58%磷...    15%   NaN   10.0%   \n",
       "178                     泥炭土 (占40%),米糠 (占20%),蔗渣 (占40%)    45%   0.0   1.67%   \n",
       "179  尿 素（养分≥46%） (占15%),生化黄腐酸钾 (占8%),磷酸一铵（养分≥58%） (...     0%   NaN     NaN   \n",
       "180  尿素 (占26.9%),磷酸二铵 (占12%),氯化钾 (占14.2%),发酵滤泥 (占46...    NaN   0.0     NaN   \n",
       "181  尿素 (占15%),腐殖酸 (占14.9%),高岭土 (占10%),氯化铵 (占30%),磷...     0%   NaN     NaN   \n",
       "182  尿素 (占10%),高岭土 (占20%),氯化铵 (占22%),肥料级磷酸氢钙 (占8%),...     0%   NaN     NaN   \n",
       "183  尿素 (占23.5%),腐殖酸 (占3.9%),高岭土 (占4%),氯化铵 (占15%),磷...     0%   NaN     NaN   \n",
       "184  尿素 (占10%),高岭土 (占16%),氯化铵 (占26%),肥料级磷酸氢钙 (占8%),...     0%   NaN     NaN   \n",
       "185  尿素 (占20%),高岭土 (占19%),农用氯化铵 (占28%),粉状磷酸一铵 (占13%...     0%   NaN     NaN   \n",
       "186  尿素 (占25%),高岭土 (占8.5%),农用氯化铵 (占29%),粉状磷酸一铵 (占17...     0%   NaN     NaN   \n",
       "187        尿素 (占25%),高岭土 (占1%),磷酸二铵  (占42%),氯化钾 (占32%)     0%   NaN     NaN   \n",
       "188  46%大颗粒尿素 (占3.38%),64%大颗粒磷酸二铵 (占24.18%),21%大颗粒硫...    NaN   NaN   15.0%   \n",
       "189  动物及动物制品 (占99.9%),发酵菌剂 (占0.1%), (占0%), (占0%), (...    45%   0.0     NaN   \n",
       "190                    甘蔗糖蜜酒精发酵废水浓缩醪液 (占99%),石灰浆 (占1%)  45.0%   0.0    4.0%   \n",
       "191  鸡粪 (占84.99%),发酵菌 (占0.01%),酒精渣 (占5%),蔗渣 (占5%),草...    50%   0.0     NaN   \n",
       "192  硫酸铵 (占12%),酒精浓缩液 (占23%),磷酸一铵 (占7%),氧化镁 (占3.8%)...    NaN   0.0     NaN   \n",
       "193  鸡粪 (占84.99%),发酵菌 (占0.01%),酒精渣 (占5%),蔗渣 (占5%),草...    50%   0.0     NaN   \n",
       "194  硫酸铵 (占60%),氯化钾 (占5%),米糟 (占30%),木薯渣 (占5%), (占0%...    20%   NaN     NaN   \n",
       "195  尿素 (占5%),膨润土 (占25%),氯化铵 (占10%),氯化钾 (占10%),磷酸一铵...    20%   NaN   6.67%   \n",
       "196  尿素 (占16.5%),酒糟 (占13%),滤泥 (占33.2%),磷酸一铵 (占15.6%...    20%   NaN     NaN   \n",
       "197          畜禽粪便 (占50%),菌种 (占2%),桐 麸 (占30%),滤泥 (占18%)    45%   0.0     NaN   \n",
       "198  牛粪 (占85%),发酵剂 (占0.03%),鸡粪 (占10%), (占0%), (占0%)...    45%   0.0     NaN   \n",
       "199  尿素 (占26%),高岭土 (占10%),55磷酸一铵 (占12%),氯化钾 (占12%),...    15%   NaN     NaN   \n",
       "\n",
       "    P2O5百分比  K2O百分比  \n",
       "0       NaN     NaN  \n",
       "1       NaN     NaN  \n",
       "2     1.67%   1.67%  \n",
       "3       NaN     NaN  \n",
       "4       NaN     NaN  \n",
       "5       NaN     NaN  \n",
       "6       NaN     NaN  \n",
       "7      2.0%    2.0%  \n",
       "8     2.33%   2.33%  \n",
       "9     2.33%   2.33%  \n",
       "10     3.0%    3.0%  \n",
       "11    3.33%   3.33%  \n",
       "12   11.67%  11.67%  \n",
       "13    3.33%   3.33%  \n",
       "14    3.67%   3.67%  \n",
       "15     4.0%    4.0%  \n",
       "16    10.0%   10.0%  \n",
       "17    10.0%   10.0%  \n",
       "18   13.33%  13.33%  \n",
       "19   15.33%  15.33%  \n",
       "20    10.0%   10.0%  \n",
       "21      NaN     NaN  \n",
       "22      NaN     NaN  \n",
       "23    1.67%   1.67%  \n",
       "24   12.67%  12.67%  \n",
       "25      NaN     NaN  \n",
       "26     4.0%    4.0%  \n",
       "27      NaN     NaN  \n",
       "28      NaN     NaN  \n",
       "29      NaN     NaN  \n",
       "..      ...     ...  \n",
       "170     NaN     NaN  \n",
       "171     NaN     NaN  \n",
       "172     NaN     NaN  \n",
       "173     NaN     NaN  \n",
       "174     NaN     NaN  \n",
       "175     NaN     NaN  \n",
       "176     NaN     NaN  \n",
       "177   10.0%   10.0%  \n",
       "178   1.67%   1.67%  \n",
       "179     NaN     NaN  \n",
       "180     NaN     NaN  \n",
       "181     NaN     NaN  \n",
       "182     NaN     NaN  \n",
       "183     NaN     NaN  \n",
       "184     NaN     NaN  \n",
       "185     NaN     NaN  \n",
       "186     NaN     NaN  \n",
       "187     NaN     NaN  \n",
       "188   15.0%   15.0%  \n",
       "189     NaN     NaN  \n",
       "190    4.0%    4.0%  \n",
       "191     NaN     NaN  \n",
       "192     NaN     NaN  \n",
       "193     NaN     NaN  \n",
       "194     NaN     NaN  \n",
       "195   6.67%   6.67%  \n",
       "196     NaN     NaN  \n",
       "197     NaN     NaN  \n",
       "198     NaN     NaN  \n",
       "199     NaN     NaN  \n",
       "\n",
       "[200 rows x 9 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result4_1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 将存在\"N+P2O5+K2O≥\"字符串的技术指标的氮，磷，钾百分比计算出取出\n",
    "for x in list(data.index):\n",
    "    i = data.loc[x]['序号']\n",
    "    if ('N+P2O5+K2O≥' in data.loc[x]['技术指标']) == True:\n",
    "        # 查找“N+P2O5+K2O≥”的位置\n",
    "        pos = data.loc[x]['技术指标'].find('N+P2O5+K2O≥')\n",
    "        # num 为氮，磷，钾的值\n",
    "        num = ''\n",
    "        \n",
    "        # str为技术指标字符串\n",
    "        strs = data.loc[x]['技术指标']\n",
    "        \n",
    "        # 将总百分比解析出来\n",
    "        for y in range(pos+len('N+P2O5+K2O≥'),len(strs)):\n",
    "            if strs[y]=='%' or strs[y]=='％':\n",
    "                break\n",
    "            else:\n",
    "                num = num+strs[y]\n",
    "                \n",
    "        # 根据得到的总百分比来计算 氮，磷，钾 的情况          \n",
    "        num = float(num)    \n",
    "        num = round(num,2)\n",
    "        \n",
    "        # 定义正则表达式\n",
    "        p = re.compile('（[0-9][0-9]―[0-9][0-9]―[0-9][0-9]）')\n",
    "#         p1 = re.compile('（[0-9][0-9]-[0-9][0-9]-[0-9][0-9]）')\n",
    "        # 判断（10―18―15）这种配比在不在字符串\n",
    "        if (p.match(data.loc[x]['技术指标']))==True:\n",
    "            # 有配比，根据配比计算 氮，磷，钾\n",
    "            x = data.loc[x]['技术指标'].split('（')[1]\n",
    "            x = x.split(')')[1]\n",
    "            \n",
    "            N = x.split('―')[0]+'%'\n",
    "            P = x.split('―')[1]+'%'\n",
    "            K = x.split('―')[2]+'%'\n",
    "            \n",
    "            result4_1.loc[result4_1['序号']==i,'总氮百分比'] = N\n",
    "            result4_1.loc[result4_1['序号']==i,'P2O5百分比'] = P\n",
    "            result4_1.loc[result4_1['序号']==i,'K2O百分比'] = K      \n",
    "        else:\n",
    "            # 无配比，根据总百分比除以三\n",
    "            N = str(round(num/3,2))+'%'\n",
    "            P = str(round(num/3,2))+'%'\n",
    "            K = str(round(num/3,2))+'%'\n",
    "            result4_1.loc[result4_1['序号']==i,'总氮百分比'] = N\n",
    "            result4_1.loc[result4_1['序号']==i,'P2O5百分比'] = P\n",
    "            result4_1.loc[result4_1['序号']==i,'K2O百分比'] = K    \n",
    "result4_1.to_excel('data/result4_1.xlsx',encoding='gbk')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "result4_1 = pd.read_excel('data/result4_1.xlsx')\n",
    "data = pd.read_excel('data/附件4.xlsx')\n",
    "NPK_data = result4_1[['总氮百分比','P2O5百分比','K2O百分比']]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 任务 4.2 设计算法或处理流程，从附件 4 原料与百分比中提取各种原料的名称及其百分比。请在报告中给出处理思路及过程， 并将结果保存到文件“result4_2.xlsx”中（参见表 2）。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 624,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>序号</th>\n",
       "      <th>产品通用名称</th>\n",
       "      <th>技术指标</th>\n",
       "      <th>原料与占比</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥35%（14-8-13）   硫酸钾型</td>\n",
       "      <td>尿素 (占15%),高岭土 (占15.5%),硫酸铵 (占28.16%),磷酸一铵 (占16...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分（N+P2O5+K2O）≥30%（15-6-9）   中氯</td>\n",
       "      <td>尿素 (占15%),高岭土 (占30.23%),氯化铵 (占28%),磷酸一铵 (占12.2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>N+P2O5+K2O≥5% ,有机质≥45%</td>\n",
       "      <td>木薯渣（干基） (占84.9%),菌种 (占0.1%),黄豆渣 (占15%)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>复混肥料</td>\n",
       "      <td>总养分(N+P2O5+K2O)≥43％ （10―18―15）含氯（低氯）</td>\n",
       "      <td>尿素 (占15%),高岭土 (占20%),粉状磷酸一铵 (占40%),氯化钾 (占25%)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>有机肥料</td>\n",
       "      <td>总养分(N+P2O5+K2O)≥5.0％ 有机质≥45％ 酸碱度（PH）  5.5∽8.5</td>\n",
       "      <td>畜禽粪便 (占50%),菌种 (占2%),桐 麸 (占30%),滤 泥 (占18%)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   序号 产品通用名称                                           技术指标  \\\n",
       "0   1   复混肥料            总养分（N+P2O5+K2O）≥35%（14-8-13）   硫酸钾型   \n",
       "1   2   复混肥料               总养分（N+P2O5+K2O）≥30%（15-6-9）   中氯   \n",
       "2   3   有机肥料                         N+P2O5+K2O≥5% ,有机质≥45%   \n",
       "3   4   复混肥料           总养分(N+P2O5+K2O)≥43％ （10―18―15）含氯（低氯）   \n",
       "4   5   有机肥料  总养分(N+P2O5+K2O)≥5.0％ 有机质≥45％ 酸碱度（PH）  5.5∽8.5   \n",
       "\n",
       "                                               原料与占比  \n",
       "0  尿素 (占15%),高岭土 (占15.5%),硫酸铵 (占28.16%),磷酸一铵 (占16...  \n",
       "1  尿素 (占15%),高岭土 (占30.23%),氯化铵 (占28%),磷酸一铵 (占12.2...  \n",
       "2             木薯渣（干基） (占84.9%),菌种 (占0.1%),黄豆渣 (占15%)  \n",
       "3      尿素 (占15%),高岭土 (占20%),粉状磷酸一铵 (占40%),氯化钾 (占25%)  \n",
       "4         畜禽粪便 (占50%),菌种 (占2%),桐 麸 (占30%),滤 泥 (占18%)  "
      ]
     },
     "execution_count": 624,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#读取数据\n",
    "data = pd.read_excel('data/附件4.xlsx')\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 处理括号函数"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 618,
   "metadata": {},
   "outputs": [],
   "source": [
    "def is_number(i):\n",
    "    i = i.replace(\"(\", \",\") \n",
    "    i = i.replace(\")\", \",\") \n",
    "    i = i.replace(',,',',')\n",
    "    s =i.split(',')\n",
    "    return s"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 626,
   "metadata": {},
   "outputs": [],
   "source": [
    "login =  data['原料与占比']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 627,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\ProgramData\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  This is separate from the ipykernel package so we can avoid doing imports until\n"
     ]
    }
   ],
   "source": [
    "login_list = []\n",
    "for i in range(len(login)):\n",
    "    login[i] = is_number(login[i])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 628,
   "metadata": {},
   "outputs": [],
   "source": [
    "subjects=[\"序号\",\"原料名称\",\"百分比\"]\n",
    "data = pd.DataFrame(columns = subjects)\n",
    "y = 1\n",
    "x = 1\n",
    "for s in login: \n",
    "    for i in s :\n",
    "        data.loc[y,'序号'] = x   # 序号表\n",
    "        pattern = re.compile('[0-9]+')\n",
    "        if pattern.findall(i):\n",
    "            a =i[1:]\n",
    "            data.loc[y,'百分比'] = a # 百分比表\n",
    "            y = y+1\n",
    "        else:\n",
    "            data.loc[y,'原料名称'] = i # 名字表\n",
    "    x = x+1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 629,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>序号</th>\n",
       "      <th>原料名称</th>\n",
       "      <th>百分比</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>尿素</td>\n",
       "      <td>15%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>高岭土</td>\n",
       "      <td>15.5%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>硫酸铵</td>\n",
       "      <td>28.16%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>磷酸一铵</td>\n",
       "      <td>16.34%</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>硫酸钾</td>\n",
       "      <td>25%</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  序号   原料名称     百分比\n",
       "1  1    尿素      15%\n",
       "2  1   高岭土    15.5%\n",
       "3  1   硫酸铵   28.16%\n",
       "4  1  磷酸一铵   16.34%\n",
       "5  1   硫酸钾      25%"
      ]
     },
     "execution_count": 629,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 630,
   "metadata": {},
   "outputs": [],
   "source": [
    "data.to_excel('data/result4_2.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
